UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kn4SHvqtiae39tKg3REGoLWu6A/2BkcZCjGk2J7tEbk='
WHERE
key_id = 'ca6fdc3c595b52ea8f33ec18b633761d638706845b77dc982c609c0399339ce4'
AND (
token = 'Kn4SHvqtiae39tKg3REGoLWu6A/2BkcZCjGk2J7tEbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)