UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'irAgqQ94dIxBPkxNiNU45UlfuTUDC7Kxk7x9Bnmzbkk='
WHERE
key_id = '5d21f30be829f2fa098ca334fc5f939cb1c4c44cf345402d5f1ec4671e19c2f4'
AND (
token = 'irAgqQ94dIxBPkxNiNU45UlfuTUDC7Kxk7x9Bnmzbkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)