UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2y6Q0W7PqWMN4zt4goexuCX1WKDbtl5Qs1wB7ylyhT4='
WHERE
key_id = '16f4c120edfffa39a56599ab9ae533d732f292731d59e212160981e72d1c1758'
AND (
token = '2y6Q0W7PqWMN4zt4goexuCX1WKDbtl5Qs1wB7ylyhT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)