UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tm63U+NTgytjiEUHFG/2ok80+C7kiHL70xq+PXMSpAE='
WHERE
key_id = 'ce4d1143bf7ffdf902a125fb9938d8b8bac2aa5325ed387a9ee0be4eb717a099'
AND (
token = 'tm63U+NTgytjiEUHFG/2ok80+C7kiHL70xq+PXMSpAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)