UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9dt6YzUwKIhv4dNLHvKZ2i/WDv/8wyq7JYktdmmN6ko='
WHERE
key_id = 'e318c95435bfad79d02322785b4439478b99eeab1855e0b37520823a8a2c5902'
AND (
token = '9dt6YzUwKIhv4dNLHvKZ2i/WDv/8wyq7JYktdmmN6ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)