UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tLP2/C1ilYDWnkLZ+eN+H7xmjPLqcfe/MkwjsfQ8zHU='
WHERE
key_id = 'aaabfdccc19b56708f61506c6a1168b76eb881e03428fa44ed3003cbf68462ab'
AND (
token = 'tLP2/C1ilYDWnkLZ+eN+H7xmjPLqcfe/MkwjsfQ8zHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)