UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hjiUHNFoqAiRByc+BAJROUBU8OP9Yml4iRuAr8RH6Q='
WHERE
key_id = '52374e1e49f1e460d58e0b658edbc4947ded2b8814ee3bf5f4854675384541c6'
AND (
token = '2hjiUHNFoqAiRByc+BAJROUBU8OP9Yml4iRuAr8RH6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)