UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQtuq9gW3NPhhuIodVsaythofKO8gRn2NivRO6jIGxU='
WHERE
key_id = '714a4abea2f834d41973f84e20d26ac9eaf8940249f8c7be4753e107794542b2'
AND (
token = 'pQtuq9gW3NPhhuIodVsaythofKO8gRn2NivRO6jIGxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)