UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1vS43cPY2oJELVwX9yjzV3u32QZXqOFieRMa4PEMHoA='
WHERE
key_id = 'eb75e6d4b751ca6c3bbfec911d55242deff239ec0f1681d23ada1b5e91e17ec2'
AND (
token = '1vS43cPY2oJELVwX9yjzV3u32QZXqOFieRMa4PEMHoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)