UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eX71PkVGWYnN0ODS5JxTIyU0SQY1MIvIvdyLREiqbTk='
WHERE
key_id = '3a396e379916bd0b82e7cfcd7b699f76b556d3d6c48255f5ec41706546f0b967'
AND (
token = 'eX71PkVGWYnN0ODS5JxTIyU0SQY1MIvIvdyLREiqbTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)