UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mGyitwiiLBIErOnMYECyayZvl33249GHkPg9o9FyCyI='
WHERE
key_id = '42a6c9b9ea6fb0af085a507736017ab1696a69e22c9ed773a722b177b6dbe034'
AND (
token = 'mGyitwiiLBIErOnMYECyayZvl33249GHkPg9o9FyCyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)