UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A4faNMthfoutNJvXXeryfsX6kYJMjNThW9r3ALhKWUM='
WHERE
key_id = 'dd45d0d1ea5ce46780b3cebcdbabee10685cf5bd70be7ef136f86dc1e1c743bf'
AND (
token = 'A4faNMthfoutNJvXXeryfsX6kYJMjNThW9r3ALhKWUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)