UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VOr0lBha7FskdDVbxnIKMwuSnDARLjSQj+4nrYb3gCU='
WHERE
key_id = 'e259665c4270fef6f6a3526372b8918f9c8b4de815ce35a79ac2c8dc16f31436'
AND (
token = 'VOr0lBha7FskdDVbxnIKMwuSnDARLjSQj+4nrYb3gCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)