UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ourgOZwZd+mCg7Bt63yZicp3XWb1tbHNPPP+dgHTBOA='
WHERE
key_id = 'a4509d9deea4aa287eebc89e6f5c93736effb3225372b8b60226711de152e8cb'
AND (
token = 'ourgOZwZd+mCg7Bt63yZicp3XWb1tbHNPPP+dgHTBOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)