UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+0Hd1ZvHze5TbJAm16x8zyjQZZcHceMeBcEHO4c/0Qc='
WHERE
key_id = 'd4b02bdc15e5bcc0823721b47d247e29df47c919ae4a32c43a8967b06b58151f'
AND (
token = '+0Hd1ZvHze5TbJAm16x8zyjQZZcHceMeBcEHO4c/0Qc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)