UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UPzXVB8zTO8c554M+F+TUOM1qgj2+CjBEfmfoPt8cTw='
WHERE
key_id = 'fc9408c78808e68be0753ee8995e188346154e9413941064036b199a413cf9eb'
AND (
token = 'UPzXVB8zTO8c554M+F+TUOM1qgj2+CjBEfmfoPt8cTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)