UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+adnYzATr1XiC0TfkQdFMbMZzk6+LGKS1IKUqIxrDLs='
WHERE
key_id = '4e7b5219f67ab42ca55f94bd636f712700fbc61f96b6229942804488aa92a033'
AND (
token = '+adnYzATr1XiC0TfkQdFMbMZzk6+LGKS1IKUqIxrDLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)