UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '94iV7zE0HSwvbzSnC6SctQsAvGj51rzW3nuKL3p/CQ8='
WHERE
key_id = 'b99553f5395021671b6d47e5ad6bacbbbc6b9fc6f5896aef1ea9b3dd4c53850b'
AND (
token = '94iV7zE0HSwvbzSnC6SctQsAvGj51rzW3nuKL3p/CQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)