UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JKzT3cGJmlgKNuy8pZdpYkZQFtECShZB4tD+cbnHHLk='
WHERE
key_id = '9b1bad6be453fab12347fdae4f0a7ba026b6ffed053d6980b03a46bc8079a4e9'
AND (
token = 'JKzT3cGJmlgKNuy8pZdpYkZQFtECShZB4tD+cbnHHLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)