UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S/6ocXxrq0EAZrE5HYTVI7hpgweGhWM7ukCngXWDMoQ='
WHERE
key_id = '50835a6887252efd7fe6e4d32810d6b01d3a936728237464e67028bc986762e7'
AND (
token = 'S/6ocXxrq0EAZrE5HYTVI7hpgweGhWM7ukCngXWDMoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)