UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3jKQwc8z5sNN3ETzQTxiwoK26nLOt1A8icmjPCyWCEg='
WHERE
key_id = 'eac224d553627c060ba853d0e7a46c5179f28e03c3482eb1b48792315a653463'
AND (
token = '3jKQwc8z5sNN3ETzQTxiwoK26nLOt1A8icmjPCyWCEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)