UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KCKGLp8Yp4FjOWDsoxC0QCL2KOTbK7XaKlIBv7HfIAQ='
WHERE
key_id = 'ea68bad5d98975b336137b87fb74ba08986b0489faf561619f44de2aa7df9956'
AND (
token = 'KCKGLp8Yp4FjOWDsoxC0QCL2KOTbK7XaKlIBv7HfIAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)