UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cWBtubI7C8esIBVKtlv5ATRencmZXwhqAP07lyLkFBE='
WHERE
key_id = '9a7a4ee97c9a9e1b5bf4f48d30008b78a386f95effe11a748b97fc06f89c299d'
AND (
token = 'cWBtubI7C8esIBVKtlv5ATRencmZXwhqAP07lyLkFBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)