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