UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kILHNulve8rZo7MWrTmC8Yirb4nY1YuJnFRePfcKbzU='
WHERE
key_id = '10be0c8cc634c606a509320fd1e3c1d75ef885d531c5a68e02d970292da43a02'
AND (
token = 'kILHNulve8rZo7MWrTmC8Yirb4nY1YuJnFRePfcKbzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)