UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kzCGT/P2qUbXIyQMiG6N4FBHw/EuH7xOVeA2zCoj4Pg='
WHERE
key_id = '308b973b417db270e1e9417f8ec7b0816d2611b34a7de72f5a5df5776780758a'
AND (
token = 'kzCGT/P2qUbXIyQMiG6N4FBHw/EuH7xOVeA2zCoj4Pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)