UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YESTc6CVZBN1k7EEUl8o93tiDoVYx8zCeW/SdjrX7QA='
WHERE
key_id = 'eda8d57d6f848cb99152972c39021c3e088900856902b7a8b86d82bd28d2c8af'
AND (
token = 'YESTc6CVZBN1k7EEUl8o93tiDoVYx8zCeW/SdjrX7QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)