UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ygYWODQB14WuvRLbel1tYTpM0Taf3eF8eIMnI++qYew='
WHERE
key_id = '29ee545b4293c6ea853a17ba7b9aba038439cac7b10c8e1faaec7146641a8ebe'
AND (
token = 'ygYWODQB14WuvRLbel1tYTpM0Taf3eF8eIMnI++qYew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)