UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihqj59tuCBIFRMcw1pZEFBNCDQaxaOALdE1R6mQatU4='
WHERE
key_id = '64112fc361365e1eeb6e4c18ce4f897a88283b7e7a1d86bf0d9b078f91af7553'
AND (
token = 'ihqj59tuCBIFRMcw1pZEFBNCDQaxaOALdE1R6mQatU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)