UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vn6dr09SqYrCkKX65lTHoWp3eFeIdhBWDCDEFZUfsls='
WHERE
key_id = 'e2c3f0a727e4e28e44520c6065cf140bdfdd5620f072c9e2ee9df921b8703114'
AND (
token = 'Vn6dr09SqYrCkKX65lTHoWp3eFeIdhBWDCDEFZUfsls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)