UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgYhkBJ0Ew+nmse6AQ+3QerHFmQG5XIGuVTfKGLPjMo='
WHERE
key_id = 'e978fa78346f74c03b6dfc180de59b68dcc33e826d83c0f18f797eae3026b192'
AND (
token = 'ZgYhkBJ0Ew+nmse6AQ+3QerHFmQG5XIGuVTfKGLPjMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)