UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HVlYwEU8cQs1+04pIuwV5yZFAh/5whdXl+Nnw77OlAc='
WHERE
key_id = '99a4e91b2d31ea567e8fa952b2d802301bc84d2be4cf47067ea80e6cfc68915f'
AND (
token = 'HVlYwEU8cQs1+04pIuwV5yZFAh/5whdXl+Nnw77OlAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)