UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gofhI3ajZZfq8W3SWNqw5wkZDzAn5DMerZ1HFJCMeMs='
WHERE
key_id = '41f142ce932bd615af1102310289e0d4a4262e5df9a00118180ea9507d7de865'
AND (
token = 'gofhI3ajZZfq8W3SWNqw5wkZDzAn5DMerZ1HFJCMeMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)