UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1u7tzUHP3IOGBE8m4WQ0ylhTOuX4XcyMNi3Lzjl3Maw='
WHERE
key_id = '9e9e7aeded04e66d6810560f5d746abf87d6619a814f632556c4f3869354093a'
AND (
token = '1u7tzUHP3IOGBE8m4WQ0ylhTOuX4XcyMNi3Lzjl3Maw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)