UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UPyyuTiit/USINHKWbw7dj26+1QSfgOrLDrZs5MCRjU='
WHERE
key_id = 'dfb5455c2a3c414c7f6ed4b92ed146718a61b86d75a9e4a02a12d28be0ff2ab8'
AND (
token = 'UPyyuTiit/USINHKWbw7dj26+1QSfgOrLDrZs5MCRjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)