UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fIyAfWyjKXBoM2D1hHIBDz/JDqbX5nrBjvPTr8SYafY='
WHERE
key_id = '45b96ebe4622c184f64186462ba55a650259e53470847be399cc21437aebeac4'
AND (
token = 'fIyAfWyjKXBoM2D1hHIBDz/JDqbX5nrBjvPTr8SYafY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)