UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zAGwBnFXPrR97G2k9Vj6pCwI3vPg9l/YlP3qSH+LKDE='
WHERE
key_id = 'f00395be58c1c500cb207bd5299e35c777fa8f498698a9d413630383d87ab680'
AND (
token = 'zAGwBnFXPrR97G2k9Vj6pCwI3vPg9l/YlP3qSH+LKDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)