UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i/N+IihHzUHcUxv1V/inwSWiltSJF1zd4Z3Bshxhp28='
WHERE
key_id = '2caa9bafb9313b1ce8e8c0a34a339dfe5fb45746f9b35a54a6dce80f5989aeb8'
AND (
token = 'i/N+IihHzUHcUxv1V/inwSWiltSJF1zd4Z3Bshxhp28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)