UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x4HsccHtm9g+XKPffpa/lJDgrCU10rkYxDGupUC5Cwk='
WHERE
key_id = '6cd816ff925b69e391943497e4da80aadd2f34416851f43ed7991e49ddee62e0'
AND (
token = 'x4HsccHtm9g+XKPffpa/lJDgrCU10rkYxDGupUC5Cwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)