UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBuGn5mUUXikfA7t6BuBqF5cStPykIaOI/V7BZxY+hA='
WHERE
key_id = 'fbddade73ef09ac56d21bf9c35a45e80b1c0b6b340c16bffdeb1177e4c68a000'
AND (
token = 'HBuGn5mUUXikfA7t6BuBqF5cStPykIaOI/V7BZxY+hA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)